/*
{
"状态":1,
"名称":"获取-款类别2",
"作者":"陈国基",
"创建时间":"2018-10-18",
"功能":"获取-款类别2",
"log": [
	{"date":"06-01" , "dev" :"hzhh" , "content" : ""}
]
}
*/
--款类别2
declare @isEdit char(1)='{isEdit}'
declare @title nvarchar(10)='全部'

if @isEdit='Y'
set @title='请选择'

select * from 
(
select @title as  category2 
union all
select Category as category2 from DictCategoryTwo 
) A 
order by case   category2 
when '全部' then 0
when '请选择' then 0
when '空' then 1 
else 2 end